{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,"Isolates 2016-17 Financial Statements"]
[null,null,"Excel File Patch"]
[]
[null,null,"This patch will update the following:"]
[null,null,"     - Schedule 1.1 Consolidated Statement of Operations"]
[null,null,"       Item 2.4 - Pupil Accomodation: formula change"]
[null,null,"       Item 2.6 - Other including Teacherages: formula change"]
[]
[]
[]
[]
[]
[null,null,"After the patch has run, you must save the workbook manually AFTER doing a check to"]
[null,null,"ensure that the patch has been applied correctly."]
[]
[null,null,"Ensure that the file being patched is open before running this patch!"]
[]
[null,null,"Click the button to begin."]

{"sheet":"Sheet2","index":1,"n_rows":63,"n_cols":12,"rows_kept":63,"cut":false,"hidden":true,"merged":[[10,0,10,10]]}
[15.3,null,"Direct Capital Grants (Specify)",null,"Estimated Expenditure",null,null,"Ministry Approval",null,"Recognized Expenditure",null,{"$f":"+A1","v":15.3}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($E$60=\"\",0,IF($H$60=\"\",$E$60,MIN($E$60,$H$60)))","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($E$61=\"\",0,IF($H$61=\"\",$E$61,MIN($E$61,$H$61)))","v":0}]
[]
["15.3.1","Special approval allocation for Direct Capital Grants (note 4)",null,null,null,null,null,null,null,{"$f":"+$J$60+$J$61","v":0},null,{"$f":"A5","v":"15.3.1"}]
[]
["1.19.1",null,"Special approval - Capital Program Grant",null,null,null,"15.3.1",null,null,null,0,{"$f":"+A7","v":"1.19.1"}]
[]
[]
[]
["Note 4: Capital expenditures for major capital projects reported in Section 15.3 as Capital Program Gratnt will be funded as the expenditures are incurred by the board. The board will need to submit monthly claims for reimbursement including supporting documentation."]
[]
["Special approval allocation for Capital Program Grant (note 4)"]
[]
["Territorial Student Program (Table 15, Col. 2, 2006-07 Guidelines)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1.25,null,"Ministry Adjustment (for Ministry use only)"]
["1.25.1",null,"Capital Program Grant",null,null,null,null,null,null,null,{"$f":"-$K$33","v":0}]
["1.25.2"]
["1.25.3",null,"Total Ministry Adjustment (Item 1.25.1 + Item 1.25.2)",null,null,null,null,null,null,null,{"$f":"+$K$57+$K$58","v":0},{"$f":"+A60","v":"1.25.3"}]
[]
[1.26,null,"Base for Grant Advances",null,null,null,null,null,null,null,{"$f":"$K$52+$K$59","v":0},{"$f":"+A62","v":1.26}]
[null,null,"(Sum of lines 1.24 and 1.25)"]